Pah 1986 I got an IBM PC XT with 20 Mb memory that I used for five years and never filled. Cost £2,500 as I recall.
Is it possible to write an Excel macro that would give you recurring four weekly dates?
My pension is paid every four weeks, so what I want is a macro where I put in the start date, and it produces the dates for the next year.
Yes, I know I can just tick it off on the calendar, but some of the clever types out there like to do these kind of things.
Is it possible to write an Excel macro that would give you recurring four weekly dates?
My pension is paid every four weeks, so what I want is a macro where I put in the start date, and it produces the dates for the next year.
Yes, I know I can just tick it off on the calendar, but some of the clever types out there like to do these kind of things.
Sub GenerateFourWeeklyDates()
Dim startDate As Date
Dim endDate As Date
Dim currentDate As Date
Dim i As Integer
' Input the start date
startDate = InputBox("Enter the start date:", "Start Date", Date)
' Input the number of occurrences (adjust as needed)
Dim numberOfOccurrences As Integer
numberOfOccurrences = InputBox("Enter the number of occurrences:", "Occurrences", 12)
' Clear existing data in column A starting from row 2
Columns("A:A").ClearContents
' Set the initial date
currentDate = startDate
' Generate dates for the specified number of occurrences
For i = 1 To numberOfOccurrences
' Output the current date in column A
Cells(i + 1, 1).Value = currentDate
' Move to the next four-weekly date
currentDate = DateAdd("d", 28, currentDate)
Next i
MsgBox "Dates generated successfully!", vbInformation
End Sub
IT team teams chat is not for mentioning issues you find or asking questions got it, thanks boss.
I get that the CFO for some obscure reason is in the chat group but if I can’t ask questions in it and we can’t chat randomly about topics it serves no purpose
I have applied to half a dozen jobs the last couple of weeks but it’s a slow period I think
IT team teams chat is not for mentioning issues you find or asking questions got it, thanks boss.
I get that the CFO for some obscure reason is in the chat group but if I can’t ask questions in it and we can’t chat randomly about topics it serves no purpose
I have applied to half a dozen jobs the last couple of weeks but it’s a slow period I think
We had a private WhatsApp in my last place.
I tried starting a teams group at my current role for the 3 of us who do GP desktop support. My colleagues appear not to like each other, they responded privately to me.
It's not what I'd call annoying but I do notice the number of screens you need to go through as you sign into a website. The best of them show your user name and password and you just click Join and you're in. Others (like Microsoft surprise surprise ) have a screen to enter your user name then click and another one to enter your password with a box to tick if you never want to see that screen again (which is a lie) and click. As I say not really annoying but a few million people signing on every day that's a lot of unnecessary clicks
It's only bad if the profile is not syncing and the user loses a file on their current machine, but then you probably wouldn't go fishing through old machines to find a lost file. Deleting the files will only mean that the next time that user logs in it will pull the profile down again meaning a longer startup time and more disk thrashing on startup but it's not a problem really. There will be cruft left in the registry regarding the old users but that shouldn't be an issue. You could run something like windirstat on the drives to find the largest folders and delete those first.So proper noob question, but it's not something I've had to deal with much before. A lot of PCs I look at are almost out of space because there are so many users profiles. I don't know if it's just our environment or the windows system properties, user profiles is always unstable, but it's a nightmare to clear them out.
How bad is it just to delete them from the C: drive without using the tool? Ideally I'd just run a powershell script to remove them all and they can be regenerated when they people who still use the PC log in.
You should be able to deploy a gpo or a scheduled task as well
It's only bad if the profile is not syncing and the user loses a file on their current machine, but then you probably wouldn't go fishing through old machines to find a lost file. Deleting the files will only mean that the next time that user logs in it will pull the profile down again meaning a longer startup time and more disk thrashing on startup but it's not a problem really. There will be cruft left in the registry regarding the old users but that shouldn't be an issue. You could run something like windirstat on the drives to find the largest folders and delete those first.
When my Ladyfriend came to stay, part of the arrangement was that she'd be WFH on the Monday. So I wasn't best pleased when she started getting DNS errors just after lunch.My partner is away this weekend and I have a change window to attempt to swap the router out and replace it with the new OPNsense setup. Rather embarrassingly I've failed miserably to do the most basic thing of getting internet to it from Virgin's modem. Currently sulking and reset opnsense to start with a blank canvas. It seems to be taking forever. Luckily I've not made any changes the old Omada setup, so hopefully I can just switch cables when I don't get this working tonight.
Edit. Bang. I must have changed something when I was clicking round exploring. I'm at least seeing my gateway.
I just got myself an RTX4080 super, this is what being single and not having kids is all about, I do feel a bit sick though at the cost but im hoping to sell my rtx4070 for quite few quid.
Hopefully.That's pretty awesome. Is that for 4k gaming?
I cancelled the order, i cant justify a grand for a gfx card , my 4070 does everything i need for now, just got over excited for a min.