How do I get the day of the week from a date in Excel?
Here are the steps to follow:Click on a blank cell where you want the day of the week to be displayed (B2)Type the formula: =CHOOSE(WEEKDAY(A2),”Sun”,”Mon”,”Tue”,”Wed”,”Thu”,”Fri”,”Sat”)Press the Return key.This should display the day of the week in short form, corresponding to the date in A2.
How do I increment a date by one day in Excel?
Auto fill a date series that increases by one dayEnter your initial date in the first cell.Click on the cell with the first date to select it, and then drag the fill handle across or down the cells where you want Excel to add dates.18 Mar 2015
How do I calculate 90 days from a date in Excel?
0:011:00Determining the Date 60 and 90 days away in Excel - YouTubeYouTube