Hey this is puneet back again and in this video we are looking at three date

functions that we can use in vba and that can be super useful for you

while working with vba in excel so the first function

that we are looking into is FileDateTime you can use this function to know that

when a file was last modified on which date and in which time

so when you enter the function name you need to enter a starting parentheses

and than you need to define the path of that particular file so I have this

MP3 file on my desktop so I am gonna get the location path of this

file and now I am gonna enter this start

with double quotation marks and than the path of the file again double quotaion marks

and than closing the parentheses to get the result

out of this function I am gonna put the cell A1

now lets run this code so it gives me 3rd of October

2021 and afternoon 3:15PM so let me

go the desktop again and check the actual

date and time on modification last modification

so it is 3rd of October 2021

afternoon 3:15PM so the result we are gettting with this function is

correct so the point is you can get date and time of last modification of any file that you have

in your system now the second function we are looking into is

date function and date function is one of the most useful function

that we have in vba library so with date function we can get the current date

so lets say if I want to insert the correct date into cell A1

I simply need to use the date function and there is no

argument that you need to define so simply need to

enter date yes thats it

so when I run this code it gives me

current data according to the date that I have in my system and insert it

into a cell A1 and if you want to get date in a specific format

other than the default format that we have in the excel you can use format function along with the date function

so it will go something like this format

and than date than you need to define the format in which you want

to enter the date into the cell

and now if I run this code so it gives me the current date

as per the format that I have specified in the format function

all right so the next function that we have is DateAdd function and

this function can be super useful for you so with the help of this function you can add a interval

into a specif date so lets say we have this 5 October

2021 in cell A2 and if I want to add five years in this

date I can use DateAdd function to that and in same way I can add months

days or even I can add time like hours minutes and seconds

so lets say if I want to add five years into this 5_October_2021

so I am gonna use DateAdd

and than I need to define the interval

that I want to add thats the format that I need to specify

than I need to define the number that how many intervals I want to add

so if I want to add five years I need to specify 5 than

date so for this I am gonna use date to get the current date

so this is the same function that we have learnt earlier so know if I run this code

so it gives me 5_October_2026 so its five years into 2021

and in the same way if you want to add months

so here I will use only m

I want to add okk

6 months and if I

run this code it gives me 5th of April 2022

so we are now into October so November December January

February March and April 5th of April so here we have few strings

to specify interval that you want to add into the date so you can use days

hours minutes months even quarters seconds weeks and years

all right so thats it for this video I hope you found this video useful and make

sure to subscribe to this channel beacuse I will be coming out of with lots of cool vba tutorials in coming weeks

I will see you next week