Microsoft Excel “TODAY” function is used to get the current Date. It is very useful function and can be used in many ways. “TODAY Function” does not have any argument that makes this easy to apply and implement.
WEEKDAY as the word suggest it is “Day count in a week”. WEEKDAY function applies to a Date and returns the output for Day of the week. The output of the function varies from 0 to 7 and by default WEEKDAY function takes “Sunday to Saturday” as a week and counts Sunday as 1st Day till Saturday as 7th Day