Good Morning,
I know this is an old topic that has been discussed many time but for some reason I haven't been able to find what I'm looking for which is simple I want excell to put the name of the month in Col. A and the date on Col. B (in the following format (20-Aug-2014) When I input data in Col G the use of the formula If combined with Now is not an option since it will change on a dalily basis and this is for a tracker so I need the dates to stay "Fixed" just to reflect when the data was input
I know this is an old topic that has been discussed many time but for some reason I haven't been able to find what I'm looking for which is simple I want excell to put the name of the month in Col. A and the date on Col. B (in the following format (20-Aug-2014) When I input data in Col G the use of the formula If combined with Now is not an option since it will change on a dalily basis and this is for a tracker so I need the dates to stay "Fixed" just to reflect when the data was input