Novice user - need formula advice ... Please.

geordie-exile

New Member
Joined
Mar 27, 2011
Messages
4
Hi all,

I'm a novice user of excel so please assume no knowledge whatsoever, I'll never be offended.

I'm trying to create a spreadsheet that highlights some key dates for appraisal reports for my staff at work. What I'm trying to do is have a due date in column M duplicate a date entered in column N, unless a date is entered in column P which is earlier than that in column N.

A date in column K must then be changed automatically to 180 days before the date in column M. I want column K to fill amber when this 180 day point is reached and turn red when 90 days is reached. I think I've worked this out with conditional formatting but I'm struggling to find information on building the formulae required for the update of dates. (My preferred format is DD/MM/YYYY or YY)

Is it possible to do this as a beginner? I'm sure the solution is probably quite simple but I have no idea how to start ...

Thanks for reading and apologies for my first post asking such a luddite question!
 

Some videos you may like

Excel Facts

How to show all formulas in Excel?
Press Ctrl+` to show all formulas. Press it again to toggle back to numbers. The grave accent is often under the tilde on US keyboards.

geordie-exile

New Member
Joined
Mar 27, 2011
Messages
4
Just wondering, am I wasting my time trying to do this? I've been mucking about with it for ages but it would appear I'm better at fixing aircraft than getting computers to work ...
 

geordie-exile

New Member
Joined
Mar 27, 2011
Messages
4
Thanks so much, that worked perfectly. It also gave me some understanding that I applied to other columns and the whole thing works great. Looks like I can learn loads here; I'm sure to be back.

Thaks again (y)
 

Watch MrExcel Video

Forum statistics

Threads
1,109,159
Messages
5,527,145
Members
409,749
Latest member
esmarques

This Week's Hot Topics

Top